Convert.JSON2XML(Convert[, Pretty, Root, Array])

Converts a properly formatted JSON string into XML.

Applies To

Convert

Properties and Methods

None

Available

The .JSON2XML(Convert[, Pretty, Root, Array]) method is available in:

17.00.026
17.01.007
All newer builds

Type

String

Syntax

Convert.JSON2XML(Convert[, Pretty, Root, Array]);

Parameters

Parameter	Required	Description
JSON	Yes	A string representing a valid JSON object
Pretty	No	An optional Boolean parameter to beautify the output
Root	No	An optional string parameter to specify the root element in the XML
Array	No	An optional Boolean parameter to include special attribute to retain array formatting

Example

let lcXML = `<Document xmlns="urn:iso:std:iso:20022:tech:xsd:pain.001.001.03" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<AdrLine>2912 Executive Parkway</AdrLine>

</PstlAdr>

<TradingPartnerId>DX7ALLSCOTTSLIQ</TradingPartnerId>

</ShipmentHeader>

</Header>

</Shipment>

</Document>`;

let loTest = Convert.XML2JSON(lcXML, true);

let lcFormName = Event.Form.Name;

Script.LogConsole("form name: " + lcFormName);

Script.LogConsole("\r\nXML -> JSON\r\n");

Script.LogConsole(loTest);

Script.LogConsole("\r\nJSON -> XML\r\n");

let lcTest = Convert.JSON2XML(loTest, true);

Script.LogConsole(lcTest);

/* Expected Output in the Web Server Console:

Console Started for Sandbox17System.

[08:38 AM] Script.LogConsole: form name: matadd

[08:38 AM] Script.LogConsole:

XML -> JSON

[08:38 AM] Script.LogConsole: {

"Document": {

@xmlns: "urn:iso:std:iso:20022:tech:xsd:pain.001.001.03",

@xmlns:xsi: "http://www.w3.org/2001/XMLSchema-instance",

Shipment: {

Header: {

ShipmentHeader: {

PstlAdr: {

PstCd: "84043",

TwnNm: "Lehi",

CtrySubDvsn: "UT",

Ctry: "US",

AdrLine: [

2912 Executive Parkway,

Ste #325

]

TradingPartnerId: "DX7ALLSCOTTSLIQ",

ShipmentIdentification: "TEST20220039300",

ShipDate: "2022-05-19",

ShipmentTime: "14:31:04",

TsetPurposeCode: "00",

ShipNoticeDate: "2022-05-19",

ShipNoticeTime: "03:44:50",

ASNStructureCode: "0001",

CarrierProNumber: "123456789123"

}